Multidatabase Querying by Context
نویسندگان
چکیده
The overwhelming acceptance of the SQL standard [10] has curtailed continuing research work in relational database query languages and processing. Since all commercial relational database systems conform with the SQL standard, there is little motivation for developing new query languages. Despite its benefits and wide-spread acceptance, SQL is not a perfect query language. Complex database schema challenge even experienced database users during query formulation. As increasing numbers of less sophisticated users access numerous data sources within an organization or across the Internet, their ability to accurately construct queries with the appropriate structure and semantics diminishes. SQL can be hard to use as it provides only physical access transparency not logical transparency. That is, a user is responsible for mapping the semantics of their query to the semantics and structure of the database. Although graphical tools for query construction and high-level programming languages mask some of the complexity, the notion of querying by structure is intrinsic to most forms of data access. In this work, we overview a new query language developed in conjunction with our integration architecture for automatically integrating relational schema. Although the major focus of this work is on database interoperability, the contribution of this paper is a language for specifying queries on the integrated view produced. The complexities of querying across database systems and resolving conflicts are too numerous to be fully described here, so this paper will discuss querying the integrated view of a
منابع مشابه
Opm*qs: the Object-protocol Model Multidatabase Query System Acknowledgements We W Ant to Thank Chris Fields and Carol Harger from the National Center for Genome Resources
We describe in this document the OPM multidatabase query system OPM QS that allows querying multiple databases that have an OPM interface using the OPM multidatabase query language OPM QL OPM is a data model that allows specifying database schemas in terms of objects and protocols laboratory experiments The OPM query language OPM QL allows querying databases that have been developed using the O...
متن کاملA Query Language and Interface for Integrated Media and Alphanumeric Database Systems
In this paper we consider a multidatabase system which con sists of media databases and traditional alphanumeric databases The semantic relationships which may exist among the objects in the me dia databases and alphanumeric databases are introduced By applying the semantic relationships the related information in the system can be integrated Therefore more powerful querying capabilities and a ...
متن کاملLimiting Result Cardinalities for Multidatabase Queries Using Histograms
Integrating, cleaning and analyzing data from heterogeneous sources is often complicated by the large amounts of data and its physical distribution which can result in poor query response time. One approach to speed up the processing is to reduce the cardinality of results – either by querying only the first tuples or by obtaining a sample for further processing. In this paper we address the pr...
متن کاملConcurrency Control in the Deomain of Multidatabase: A Semi-semantic Approach
Multidatabase is a promising approach to achieving interoperability among various DBMSs. The latest development in distributed object management techniques enlarges the scope of multidatabase system. This paper explores the trade-o between the concurrency achieved and the extra overhead incurred by the semantic-based concurrency control. It proposes a semisemantic approach to rationalize the co...
متن کاملInterBase-KB: Integrating a Knowledge Base System with a Multidatabase System for Data Warehousing
This paper describes the integration of a multidatabase system and a knowledge-base system to support the data-integration component of a Data Warehouse. The multidatabase system integrates various component databases with a common query language, however it does not provide capability for schema integration and other utilities necessary for Data Warehousing. The knowledge base system offers in...
متن کامل